package com.wl.zk.zkclient;

import org.apache.commons.dbcp2.BasicDataSource;
import org.apache.commons.dbcp2.BasicDataSourceFactory;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

public class DBCPUtilsTest {
    public static void main(String[] args) throws Exception {
//        Connection conn = DBCPUtils.getConnection();
//        DBCPUtils.closeAll(null,null,conn);

        Properties properties = new Properties();
        properties.setProperty("driverClassName","com.mysql.jdbc.Driver");
        properties.setProperty("url","jdbc:mysql://192.168.198.123:3306/test1?useUnicode=true&characterEncoding=utf-8&useSSL=false");
        properties.setProperty("username","root");
        properties.setProperty("password","12345678");
        System.out.println(properties);
    }
}
